Functions remap example

A Function remap applies a standard function (for example, UCASE) to an existing field to create a new field.

The script is written in the following format:

If you are using the Data Transformation wizard, these entries relate to the column fields as follows:

The following example creates a new field called First Name containing names in upper case, taken from the Forename column of the Person table.

• Data Transformation Examples
  • Decode Remap Examples
  • Numeric Remap Example
  • Functions Remap Example
    • List of Functions
  • Parametric Remap Example
  • Quantile Remap Example
  • Expression Based Dynamic Fields Example
  • Aggregate Based Dynamic Fields Example